UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JVjuoJmdHZk+gD5V9pR4jaHAUfJ7Tyd9palatlxprL8='
WHERE
key_id = '0cc06dc5a4d36c3456ba353774ebb79642715f1a0980fcb0cadee18a6cf02638'
AND (
token = 'JVjuoJmdHZk+gD5V9pR4jaHAUfJ7Tyd9palatlxprL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)