UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'beCZNR3Y+pLiZS48EDALXYJubYmiBm+Xr/2V1uy1Ln0='
WHERE
key_id = '3ef15379398760ac6b815be67ad26310ab99cb61ec5232f80214d7b16636a3a4'
AND (
token = 'beCZNR3Y+pLiZS48EDALXYJubYmiBm+Xr/2V1uy1Ln0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)