UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lSw2hY+ewyvbOW902aFgJLtoXDqRF9DPfHsK8A65k8o='
WHERE
key_id = 'e531bea0bbe43f016e679f40b9a6fe1b2cb8b3544d69223c1e5cad5c007fb224'
AND (
token = 'lSw2hY+ewyvbOW902aFgJLtoXDqRF9DPfHsK8A65k8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)