UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zs+WUQKy1LfUhKGnCyE8tC4pY5OqD3MngTA9hqtV8Xw='
WHERE
key_id = '0ff5251bf1bc119611e2defc26deb48bee006192fb12961de5ae153b6d29655c'
AND (
token = 'zs+WUQKy1LfUhKGnCyE8tC4pY5OqD3MngTA9hqtV8Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)