UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7YXLpbi+2dIT8KpcaDeAP7ErpfkpoRM+HbPJDO5EQGI='
WHERE
key_id = '7cd78f919b6c46e60bcddc298c6986c952a0f182407f8a1859e0df65031caaa6'
AND (
token = '7YXLpbi+2dIT8KpcaDeAP7ErpfkpoRM+HbPJDO5EQGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)