UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HbJEa2mQboL8UTURhrw3vOCxVOsfy0OR3vPY2pK8YbE='
WHERE
key_id = '9ab4d677beca11bf508f7a7def1c864dda5d1f2b32d55464da52e9debe095828'
AND (
token = 'HbJEa2mQboL8UTURhrw3vOCxVOsfy0OR3vPY2pK8YbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)