UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'retpEPohXYWCGVjjO1MoSkNgMQGbc2Hhx6ClNGteLVE='
WHERE
key_id = 'e6fa54bb0e5b68c07f1b73fc4ad79f251959436828010afaa9a466b266b69379'
AND (
token = 'retpEPohXYWCGVjjO1MoSkNgMQGbc2Hhx6ClNGteLVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)