UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+N4Fmsw5tnCebdOxjkWpXSc0Q5kfmjWGcfe5TNTtAhQ='
WHERE
key_id = '277e00a51a5abb9748ed2898ef4d473e119fd7e5c6aef8ebadf8ba38f390645a'
AND (
token = '+N4Fmsw5tnCebdOxjkWpXSc0Q5kfmjWGcfe5TNTtAhQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)