UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ae6EGA/90sH2Wnge+yjvv3sLSMUAm5BM7gJpS9DFIGA='
WHERE
key_id = '293604c0aa9acb53329d386e9808a113a6a612f4045cb4e3a0a3e641acd43380'
AND (
token = 'ae6EGA/90sH2Wnge+yjvv3sLSMUAm5BM7gJpS9DFIGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)