UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YLj7y1w95sJR6RwcwfK4cUzhroDyeON8pfpqIiCOsw='
WHERE
key_id = 'de4f4c185c4d475b4b99d77e0a136865e5e56becac465849b9c1579ca8aef2ea'
AND (
token = '8YLj7y1w95sJR6RwcwfK4cUzhroDyeON8pfpqIiCOsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)