UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tYj6hQmA5O3KgvY6v1/V0nckb6ebNafiv8sKM42v3EE='
WHERE
key_id = '578f88c423564330fdb886b9ef55e4b275b96ac75f37547b14024eaf376ac936'
AND (
token = 'tYj6hQmA5O3KgvY6v1/V0nckb6ebNafiv8sKM42v3EE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)