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