UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8KxpKh4sE4224TXVo4h9cg3K9GlJzXS3BWg9S8+yBLs='
WHERE
key_id = '9497f8ab937fb5b7e73d00885960b0b6f90d6a1b6029f5b8f6dd2ff6cced539d'
AND (
token = '8KxpKh4sE4224TXVo4h9cg3K9GlJzXS3BWg9S8+yBLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)