UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNZJs3Tal/+GeCU9bLjj9H90V74BIb0J//RuXv1lJxU='
WHERE
key_id = '827cd36d2ff0dba945c355a46675478e0aafead34bbe4172bf39dcd26685e528'
AND (
token = 'nNZJs3Tal/+GeCU9bLjj9H90V74BIb0J//RuXv1lJxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)