UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CFJ7agBDcTR9MvZPNN77F51HcozzPHrrs0hm4snabE='
WHERE
key_id = '67033a3a62f9d0a3c5f811ef0147b2cc1a07fb20d3811941bc86a7730e6c782c'
AND (
token = '/CFJ7agBDcTR9MvZPNN77F51HcozzPHrrs0hm4snabE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)