UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v8KzxyzznIQPaHoDzHd3AhlngW2TqBigzm2lWXJEjU4='
WHERE
key_id = '89cc7b953449a532580d2b1116718758af665dbb4ec2a82ac4207a617befe0dd'
AND (
token = 'v8KzxyzznIQPaHoDzHd3AhlngW2TqBigzm2lWXJEjU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)