UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '25O6tIKzdSmU6YIEpUYk4n160Zi7gt65lcI5RrJZxCs='
WHERE
key_id = '00a5e65c4b05a9bd0b4521537a23232db28188f7fb57e7047a25b799fdd4d868'
AND (
token = '25O6tIKzdSmU6YIEpUYk4n160Zi7gt65lcI5RrJZxCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)