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