UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tcQzctQfNR06pd+1jCzpwk82VjH/9EJ5g1FxA3YQx8='
WHERE
key_id = 'f02dabaed78289d3d84c00b33537585373d5134acb07fd26514db3171cf03d7d'
AND (
token = '0tcQzctQfNR06pd+1jCzpwk82VjH/9EJ5g1FxA3YQx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)