UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8SWpMtCTNlNTEqbiEkpAtIDH3VZUtcqXWZTlxHLpZw='
WHERE
key_id = 'aa3d63d6eccd4f48e0157eb7de376a43626a16b715a1be723ccb4355ae42edd3'
AND (
token = 'z8SWpMtCTNlNTEqbiEkpAtIDH3VZUtcqXWZTlxHLpZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)