UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u2j3LRge1SjnZbeT3ChXd+CH8gIgIWHfYUzwfCy7IDY='
WHERE
key_id = '1f9fb7d82973282ffc78b976f13cf1411c1434c1478f0ec95df7ed61ade4fd79'
AND (
token = 'u2j3LRge1SjnZbeT3ChXd+CH8gIgIWHfYUzwfCy7IDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)