UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+aYbgvl7rA1QGdNC4Xu1L1bRLJlgnXN8+UJARKAgxc='
WHERE
key_id = '8a6e720708592a1fb5fc8c3c36ab048240abaf81a9899a978f889362c43c8833'
AND (
token = 'z+aYbgvl7rA1QGdNC4Xu1L1bRLJlgnXN8+UJARKAgxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)