UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iL71kiLZnAsbIV9qFM2t+q8liMeHPED/oGzPGjSC680='
WHERE
key_id = '6710b9333cf14153f5c7daef45ccb1484330b4e4d61f955d00dea181f9a3405f'
AND (
token = 'iL71kiLZnAsbIV9qFM2t+q8liMeHPED/oGzPGjSC680='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)