UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6eRofrFBm7B/OO8oe5I1+eREU92GQrOTwwyf7s6JZq8='
WHERE
key_id = 'f78b525a67e851b3be5750492e3c66e2a754eff984e7b66af63cb65f6398ecea'
AND (
token = '6eRofrFBm7B/OO8oe5I1+eREU92GQrOTwwyf7s6JZq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)