UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHsr7UgOs9l74f/iAgiMbCP2sA9F60fhF5YPqMBqgZw='
WHERE
key_id = '9640c737970189776c0905f16aee47bffae6b7cde48a21cd37f985b869e83155'
AND (
token = 'hHsr7UgOs9l74f/iAgiMbCP2sA9F60fhF5YPqMBqgZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)