UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8+X9z4KljxtNt/jF3v5U40AfN/eiWmVXE0f4oR4f5U='
WHERE
key_id = '9aa302e5ec766a5edd5e46f90347b3b73ef8cd8de53e0832266aa930cf32df64'
AND (
token = 'a8+X9z4KljxtNt/jF3v5U40AfN/eiWmVXE0f4oR4f5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)