UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBNTztB++M8YDgOh5zvsHuLosojLpK7IG6Yohsyzluw='
WHERE
key_id = '830e8fde458d11e3858e57b9253026d988c1067e662e3d81a52f661ac7587893'
AND (
token = 'tBNTztB++M8YDgOh5zvsHuLosojLpK7IG6Yohsyzluw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)