UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vz8GScZXLYmgtq2ob5c7MSeO+NQj7IALpOqeSN4NuSg='
WHERE
key_id = 'a1d21c98bbc09a31bfcebfa823f72e290c04a89eadbe76fd02e78fc5931bb24b'
AND (
token = 'Vz8GScZXLYmgtq2ob5c7MSeO+NQj7IALpOqeSN4NuSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)