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