UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XB5BjoH81VBEnyLWYiUAGlpM2DT4Tlh9vw/hkaDVJc='
WHERE
key_id = '0ca1355fa4e4db6b8ce612f6fed11f34ecdde7c0737ce9ad0816a4df28d81004'
AND (
token = '9XB5BjoH81VBEnyLWYiUAGlpM2DT4Tlh9vw/hkaDVJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)