UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LgZXpoFPXsfwie71iuvpPW/ZS7RtVE183A6PpOv3cc4='
WHERE
key_id = '14e7904384cb85982c839272a34b7afe1501800a68944d8acfba0e7f0755237c'
AND (
token = 'LgZXpoFPXsfwie71iuvpPW/ZS7RtVE183A6PpOv3cc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)