UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9fWGLyz9zJGWBgdoKVjkSUqWQgYC31Sj14mhMT1hxn4='
WHERE
key_id = '7f36974fbb45ff5629981e77b3ca7d0a16eeb3bfb374534a285f1f8f2d85bc1a'
AND (
token = '9fWGLyz9zJGWBgdoKVjkSUqWQgYC31Sj14mhMT1hxn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)