UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZP3+p7Entw7VIJyemlvhHZIJv/5AlW3IVnD09ik7ERk='
WHERE
key_id = '4638bf34d1d78d180965f4ef44a0f15845a95fd28a073afaf8a8ec8b33b8258f'
AND (
token = 'ZP3+p7Entw7VIJyemlvhHZIJv/5AlW3IVnD09ik7ERk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)