UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fGpshQPVt0vzf/QxOZRLzG+xjiQi1p5Hk10sISwmeHE='
WHERE
key_id = '229f8813c0686044804d49832371d88bf7cbde008d40ace1abe6506764cbfdad'
AND (
token = 'fGpshQPVt0vzf/QxOZRLzG+xjiQi1p5Hk10sISwmeHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)