UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qbDFvFzshg3g9K9NMDfg+q5ghqYen6L8BWMuVRsH/Lk='
WHERE
key_id = 'e2e8a74b984dedd1662e8ec47a9ea040245aa526bf3e287445741b1daf88dca6'
AND (
token = 'qbDFvFzshg3g9K9NMDfg+q5ghqYen6L8BWMuVRsH/Lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)