UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IYaMoLpPcPulmSygTbQf4CCRjriJ1lOJt4NhQg5vmwc='
WHERE
key_id = 'cf3079d518413c1c63d4b9aa5abe735588323db531244acb90931dc24a142346'
AND (
token = 'IYaMoLpPcPulmSygTbQf4CCRjriJ1lOJt4NhQg5vmwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)