UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QbBcNZjJRg+047G6EH/xYaGHpA+p0hcBIcwVd3XfOHQ=' 
WHERE 
  key_id = '0e250f6f262b7f9c5df052be09249d5384a40b7e1453b3c08f9e1f5032954ce3' 
  AND (
    token = 'QbBcNZjJRg+047G6EH/xYaGHpA+p0hcBIcwVd3XfOHQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024