UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BX0ZIg9eFsUeWNetdHbM1fMAnwqs15IpT1Utv4pSojo='
WHERE
key_id = '6fd93927076174142981a878d29f454a0e0d685bb89f1a079da2bd0e9a61f34b'
AND (
token = 'BX0ZIg9eFsUeWNetdHbM1fMAnwqs15IpT1Utv4pSojo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)